﻿/*CREATE TABLE [dbo].[BillSearchResults] (
    [Id]                   NVARCHAR (100) NOT NULL,
    [Title]                NVARCHAR (MAX) NOT NULL,
    [Date]                 DATETIME       NOT NULL,
    [Summary]              NVARCHAR (MAX) NOT NULL,
    [IndexedContent]       NVARCHAR (MAX) NOT NULL,
    [Portfolio]            NVARCHAR (MAX) NOT NULL,
    [Sponsor]              NVARCHAR (MAX) NOT NULL,
    [FirstReadingHTMLLink] NVARCHAR (MAX) NOT NULL,
    [AsPassedHTMLLink]     NVARCHAR (MAX) NOT NULL,
    [FoundInFirstReading]  BIT            NOT NULL,
    [FoundInAsPassed]      BIT            NOT NULL,
    [Status]               NVARCHAR (MAX) NOT NULL,
    [Type]                 NVARCHAR (MAX) NOT NULL,
    [ParliamentNumber]     INT            NOT NULL,
    [OriginatingChamber]   NVARCHAR (MAX) NOT NULL
);*/





